<?php
include('conf/connect.php');
$hid=$_GET['hid'];
$aql="UPDATE acute SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE adult_question SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE answers SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE chronic SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE cod SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE education SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE elapsed_time SET hhid='00000' WHERE hhid='$hid'";
mysql_query($aql);
$aql="UPDATE household_asset SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE household_economic SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE household_info SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE marital1 SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE marital2 SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE med1 SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE med2 SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE outpatient SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE questions SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);
$aql="UPDATE raw_data SET hid='00000' WHERE hid='$hid'";
mysql_query($aql);

echo "Data truncate for ".$hid;
?>